# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年12月28日
"""
import pandas as pd

data = pd.read_excel('./data/all.xlsx')
view = data.describe(percentiles=[], include='all', datetime_is_numeric=True).T
view['null'] = len(data)-view['count']
view = view[['null','max','min']]
view.columns=[u'空值数',u'最大值',u'最小值']
print(view)
view.to_excel('./data/result.xlsx')